Creating calculated column. 10

Before you start with you measures please make sure you created all calculated column you need for this project the reason I am saying this I had experience with trying sort column after  I had a bit challenge so make sure you created your calculated column before 

 To create calculated

    A . On power bi ribbon you will see Transform Data click on that and another  power Query window will   appear

Then select created column. Once you done that on power bi ribbon select add column see the screenshot below 


Select column from example there will be a dropdown choose from selection see the screenshot below 



1.  Week of Year On the highlighted area type week then  choose  Week of the year created. And then ok.

2.  Start of Week select created and the add. column form example then from selection and type week and you will see Start of the           week form created select and then ok.

3.  End of Week select created and then column form example and from selection and then type week select End of the week from created.  and then close and apply.

see gif below 


you should able to see this after you closed and apply 



Calculated Columns and Measures in DAX - SQLBI